An Approach of SQL to JSON Transformation For Handling Database Operations

Nowadays NOSQL databases are becoming more popular. Companies like Google, Facebook, and Amazon has created their own NOSQL databases based on their requirements. Different types of querying approaches are followed by different NOSQL databases, whereas traditional databases like MySQL, ORACLE, etc. follows SQL for querying. Most of the companies are shifting from traditional databases to NOSQL databases depending upon their requirements. But the problem they encounter is the change of the querying approach where the majority of the code needs to get refactored. This paper proposes the initial step of research on how to create and manage databases with SQL as the querying approach. In a cloud computing environment, most of the research is being done for making REST as the querying approach for various data stores. This paper also proposes an SQL-to-NOSQL scheme transformation over MySQL and CouchDB. KeywordsDBMS, JsonDB, NoSQL, SQL, JSON